Partition Functions

A partition function is a function in the current database that maps the rows of a table or index into partitions based on the values of a specified column.

Note: Support from SQL Server 2005 or later.

Just simply click -> Partition Function to open an object pane for Partition Function. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit and delete the selected partition function.

Create Partition Function

To create a new partition function

To create a new partition function with modification as one of the existing partition function

Edit Partition Function

To edit the existing partition function (manage its general etc)

To change the name of the partition function

Delete Partition Function

To delete a partition function

Achieve Partition Function Information

To achieve a partition function information